Appendix A: Join Selected Data Objects

Joining database objects gives you access to additional data, depending upon how they are joined.

The available join types are as follows:

  • Inner Join: This join type returns all the rows of data that match the selected criteria. This is the most commonly used type of join and is the default selection for the Reporting Tool.
  • Left Join: This join type is also called a left outer join. The resulting list displays all data rows from the first selected object, even if there is no corresponding matching data and only the rows that match the selected criteria from the second data object.
  • Right Join: This join type is also called the right outer join. The resulting list displays all data rows from the second selected object but only the rows from the first data object that match the selected criteria.

The Join Editor lets you add multiple join conditions. It allows you to add conditions that match columns against constant values, such as dates or strings, as well as match columns across tables.

The most common fields that Deltek Talent uses to link the tables are marked with an asterisk (*). You can also select an operator to join the tables.